Data Warehouse Data Dictionary

Field Rules

The following rules apply for the CustomerClosed In the context of the Cloud Monetisation Platform, an individual or organisation who has signed an agreement to take goods and services from a service provider. A customer receives a bill associated with one or more subscriptions, and can be a single end user or a large company with many subscriptions assigned to one agreement. Data and Configuration Data extract fields in the Customer Data Extracts.

  • All fields are comma (,) delimited with no leading or trailing record comma.
  • Numeric amounts are not encased by quotation marks, for example 123.
  • Alphanumeric fields are not encased by quotation marks, for example ,TARIFF.
  • Date/time fields are not encased by quotation marks, for example 2020-07-17T10:01:17+0100.
  • A non-monetary numeric amount is a straight forward character conversion. If the value is zero it is represented as ,0,.

  • For monetary amounts, an edit code is applied for formatting purposes:

    12345.67 Debit amount
    12345.67- Credit amount
    .00 Zero

    Additionally if the amount is 0.67, the leading 0 is dropped and represented as .67 (or .67- if credit amount).